[ROOT] dt FactInternetSale PIVOT OrderDate.YearMonth() BY DimCurrency.AlternateKey SUM SalesAmount SELECT *.TMB() AS * ORDER BY OrderDate.YearMonth()Id DESC > TITLE Internet sales per year and month
39 items
| OrderDate.YearMonth()Id | _SUM | AUD | CAD | DEM | FRF | GBP | USD |
|---|---|---|---|---|---|---|---|
| 2025-03 | 36.6K | 0 | 0 | 0 | 0 | 0 | 36.6K |
| 2025-02 | 1.3M | 301K | 81K | 0 | 0 | 184K | 707K |
| 2025-01 | 1.9M | 469K | 146K | 0 | 0 | 207K | 1.1M |
| 2024-12 | 1.8M | 442K | 127K | 0 | 0 | 212K | 973K |
| 2024-11 | 1.5M | 396K | 81K | 0 | 0 | 182K | 826K |
| 2024-10 | 1.5M | 406K | 92K | 0 | 0 | 192K | 800K |
| 2024-09 | 1.4M | 444K | 93K | 0 | 0 | 181K | 701K |
| 2024-08 | 1.6M | 348K | 140K | 0 | 0 | 202K | 900K |
| 2024-07 | 1.4M | 371K | 80K | 0 | 0 | 210K | 765K |
| 2024-06 | 1.1M | 341K | 69K | 0 | 0 | 134K | 515K |
| 2024-05 | 1.1M | 337K | 59K | 0 | 0 | 132K | 524K |
| 2024-04 | 889K | 203K | 65K | 0 | 0 | 134K | 486K |
| 2024-03 | 870K | 237K | 44.4K | 0 | 0 | 132K | 456K |
| 2024-02 | 628K | 213K | 16.3K | 0 | 0 | 78K | 321K |
| 2024-01 | 560K | 215K | 15.3K | 0 | 0 | 61K | 269K |
| 2023-12 | 548K | 201K | 23.5K | 0 | 0 | 58K | 265K |
| 2023-11 | 492K | 199K | 24.7K | 0 | 0 | 64K | 204K |
| 2023-10 | 502K | 218K | 18.7K | 0 | 0 | 61K | 204K |
| 2023-09 | 461K | 189K | 20.4K | 0 | 0 | 62K | 189K |
| 2023-08 | 551K | 209K | 21.2K | 0 | 0 | 68K | 252K |
| 2023-07 | 415K | 128K | 12.0K | 0 | 0 | 67K | 208K |
| 2023-06 | 389K | 169K | 17.4K | 0 | 0 | 42.7K | 160K |
| 2023-05 | 373K | 140K | 15.0K | 0 | 0 | 52K | 165K |
| 2023-04 | 473K | 138K | 26.1K | 0 | 0 | 60K | 249K |
| 2023-03 | 506K | 127K | 39.6K | 0 | 0 | 51K | 288K |
| 2023-02 | 585K | 156K | 64K | 0 | 0 | 27.5K | 338K |
| 2023-01 | 684K | 232K | 51K | 0 | 0 | 43.1K | 358K |
| 2022-12 | 716K | 240K | 64K | 0 | 0 | 28.7K | 383K |
| 2022-11 | 604K | 218K | 35.6K | 0 | 0 | 39.2K | 311K |
| 2022-10 | 611K | 180K | 53K | 0 | 0 | 36.4K | 341K |
| 2022-09 | 602K | 233K | 43.3K | 0 | 0 | 75K | 251K |
| 2022-08 | 682K | 219K | 47.0K | 37.3K | 22.9K | 65K | 291K |
| 2022-07 | 612K | 257K | 40.4K | 43.6K | 47.3K | 30.5K | 194K |
| 2022-06 | 522K | 203K | 12.6K | 55K | 11.4K | 37.7K | 202K |
| 2022-05 | 483K | 198K | 10.7K | 18.6K | 33.4K | 64K | 158K |
| 2022-04 | 510K | 184K | 32.5K | 40.8K | 18.2K | 63K | 171K |
| 2022-03 | 495K | 249K | 22.0K | 32.0K | 43.9K | 34.8K | 113K |
| 2022-02 | 117K | 42.9K | 3.6K | 10.7K | 3.4K | 14.8K | 41.1K |
| _SUM | 29.4M | 9.1M | 1.8M | 238K | 181K | 3.4M | 14.7M |
Generated 2025-03-22 18:08:06.361 UTC